Tabela PrescriptionStatusText

Definicja tabeli PrescriptionStatusText

Name

PrescriptionStatusText

Code

PrescriptionStatusText

Comment

status recepty


Lista kolumn tabeli PrescriptionStatusText

Name

Code

PrescriptionStatusID

PrescriptionStatusID

LanguageID

LanguageID

FullName

FullName

ShortName

ShortName

Description

Description

Code

Code


Kolumna PrescriptionStatusID tabeli PrescriptionStatusText

Definicja kolumny PrescriptionStatusID tabeli PrescriptionStatusText

Name

PrescriptionStatusID

Code

PrescriptionStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID statusu recepty


Kolumna LanguageID tabeli PrescriptionStatusText

Definicja kolumny LanguageID tabeli PrescriptionStatusText

Name

LanguageID

Code

LanguageID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna FullName tabeli PrescriptionStatusText

Definicja kolumny FullName tabeli PrescriptionStatusText

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna ShortName tabeli PrescriptionStatusText

Definicja kolumny ShortName tabeli PrescriptionStatusText

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

Yes

Comment

 


Kolumna Description tabeli PrescriptionStatusText

Definicja kolumny Description tabeli PrescriptionStatusText

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna Code tabeli PrescriptionStatusText

Definicja kolumny Code tabeli PrescriptionStatusText

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

Yes

Comment

 


Lista kluczy tabeli PrescriptionStatusText

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PrescriptionStatusText

Definicja klucza Identifier_1 tabeli PrescriptionStatusText

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment